package com.eascs.crm.nsEditDetail.dao;

import java.util.List;

import org.springframework.stereotype.Repository;

import com.eascs.admin.common.dao.BaseO2oDao;
import com.eascs.crm.nsEditDetail.entity.CustomerShopInfoEntityNew;
@Repository
public class NsEditDetailDao extends BaseO2oDao{
	
	public List<String> findCustomerShopId(String loanapplyNo){
		String sql = "SELECT t.customer_shop_id FROM customer_shop_info t WHERE t.loanapply_no=? AND t.islock='N' ";
		return this.findSimpleObjectList(sql, String.class, loanapplyNo);
	}
	
	public CustomerShopInfoEntityNew queryByIdnew(String id) {
		String sql = "SELECT * FROM customer_shop_info t WHERE t.customer_shop_id=? ";
		return this.findEntity(sql, CustomerShopInfoEntityNew.class, id);
	}
}
